Returns the first
specified number of elements in a set, while retaining
duplicates.
______________________________________________________________________
Create query
with:
·
Place next
level State Province in Row area
·
Place
measure MarkUp in Data area
Now to get only first
five (5) members:
·
Select
Dimension Function for hierarchy Customer.hCountry
·
Select
function First N
NOTE: When you have only one dimension on axis it is
absolutely the same if you
use Axis, Dimension or Element
function.
However, whenever possible use Dimension
functions.
Dialog will
appear:
·
Change value
of 100 to 5
·
Select
OK
·
Select
Run
First five members are at
the table.